/**
 * Licensed to Open-Ones Group under one or more contributor license
 * agreements. See the NOTICE file distributed with this work
 * for additional information regarding copyright ownership.
 * Open-Ones Group licenses this file to you under the Apache License,
 * Version 2.0 (the "License"); you may not use this file
 * except in compliance with the License. You may obtain a
 * copy of the License at:
 *
 * http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing,
 * software distributed under the License is distributed on
 * an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
 * KIND, either express or implied. See the License for the
 * specific language governing permissions and limitations
 * under the License.
 */
package oog.product.dao;

import java.util.List;

import oog.product.entity.Product;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;

/**
 * @author ThachLN
 */
public class ProductDao {
    
    public static Product addProduct(Product product) {
        Session sess = HibernateUtil.getSession();

        Transaction tx = null;
        try {
            tx = sess.beginTransaction();
            sess.save(product);
            tx.commit();
            return product;
        } catch (RuntimeException rex) {
            if (tx != null) {
                tx.rollback();
            }
            return null;
        } finally {
            sess.flush();
            sess.close();
        }
    }

    public static Product getProduct(String name) {
        Session sess = HibernateUtil.getSession();

        Transaction tx = sess.beginTransaction();
        Product product = (Product) sess.get(Product.class, null);
        tx.commit();

        return product;
    }

    /**
     * [Give the description for method].
     * 
     * @param text
     * @return
     */
    public static List<Product> searchByText(String text) {
        Session sess = HibernateUtil.getSession();
        List<Product> productList = sess.createQuery("select p from Product as p").list();

        sess.close();
        return productList;
    }
    /**
     * [Give the description for method].
     * 
     * @param fromChar
     * @param toChar
     * @return
     */
    public static List<Product> searchByAlphabet(char fromChar, char toChar) {
        Session sess = HibernateUtil.getSession();
        List<Product> productList = sess.createQuery("select p from Product as p").list();

        sess.close();
        return productList;
    }
}
